Viewing 15 posts - 9,856 through 9,870 (of 49,571 total)
BrainDonor (3/3/2014)
SQL Bits XII has finally been announced http://www.sqlbits.com/.
Wooot!
Next problem, what do I submit?
March 3, 2014 at 4:54 am
You need to drop all constraints, check constraints, foreign key, unique constraints, not disable them.
March 3, 2014 at 4:49 am
SQL_Surfer (3/2/2014)
After waiting for a while, I was able to detach the db, rename the log file and then attach it back without the log file.
Excellent way of destroying...
March 3, 2014 at 4:48 am
ALTER DATABASE ... MODIFY FILE
Take the DB offline (no need to restart SQL)
Copy the file to its new location
Bring the DB online
Practice on a non-production server first.
February 28, 2014 at 5:19 am
danielfountain (2/28/2014)
Surely if it was the where clause causing this issue then this would get round the issue.
No.
All you've done there is add an extra layer which the parser will...
February 28, 2014 at 5:02 am
Are there any answers for teams other than Team1 which have non-numeric values? If so, that's probably the cause. The case could be occuring on rows which would later be...
February 28, 2014 at 2:38 am
If you're using SQL 2012, use the 'catch-all' form (where Column=@Parameter or @Parameter IS NULL) and add the OPTION (RECOMPILE) to the query.
February 28, 2014 at 1:37 am
yuvipoy (2/27/2014)
Client needs the configuration with SQL Server 2012 on windows xp (if possible, else we would suggest other OS to client).
I would suggest a server operating system for a...
February 28, 2014 at 12:42 am
Views and stored procs are stored within the system tables (they're just saved code), system tables are always on primary. While you can join from sys.indexes to sys.objects it will...
February 27, 2014 at 2:47 pm
February 27, 2014 at 1:55 pm
rodjkidd (2/27/2014)
February 27, 2014 at 1:08 pm
Ken.Cushing (2/27/2014)
February 27, 2014 at 9:35 am
DBO does not include trace permissions. You need to explicitly grant him the ALTER TRACE permission at the server level.
GRANT ALTER TRACE TO <login name>
The only fixed role which...
February 27, 2014 at 7:25 am
You need at least enough free space to hold the largest index (for a rebuild), otherwise the DB will grow
Other than that, OK/acceptable in terms of what?
If you have...
February 27, 2014 at 7:02 am
Koen Verbeeck (2/27/2014)
Maybe you can create an indexed view.
Maybe, maybe not. Might make other things worse, might not be possible. No way to tell.
February 27, 2014 at 6:41 am
Viewing 15 posts - 9,856 through 9,870 (of 49,571 total)