Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
Solved
tsql computed function not responding with huge record
Posted on 2012-12-25
i have create new column and i have add this function
and i got this message
- Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
every time i get new record on this table who i can solve it ?
CASE DATEPART(WEEKDAY,datetimein) WHEN 1 THEN 'SU' WHEN 2 THEN 'MO' WHEN 3 THEN 'TU' WHEN 4 THEN 'WE' WHEN 5 THEN 'TH' WHEN 6 THEN 'FR' WHEN 7 THEN 'SA' END
and i got this message
- Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
every time i get new record on this table who i can solve it ?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
first, you could simplify the formula like this:
ucase(left(datename(wk, datetimein),2))
anyhow, for large table(s), the GUI will give you eventually a timeout.
running the t-sql directly will run without timeout, as long as needed.
ucase(left(datename(wk, datetimein),2))
anyhow, for large table(s), the GUI will give you eventually a timeout.
running the t-sql directly will run without timeout, as long as needed.
your function is better but the problem when i putted as computed column give same problem :S UPPER(left(datename(WEEKDA
did you try to save the change script, and run it from T-SQL windows instead from table's design view?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
Windocks is an independent port of Docker's open source to Windows. This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
- SQL
- Microsoft SQL Server
- AWS
- Azure
- Docker
- *DevOps
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses
Course of the Month11 days, 13 hours left to enroll
730 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.