Viewing 15 posts - 916 through 930 (of 1,170 total)
Hi
Here are some links:
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
http://msdn.microsoft.com/en-us/library/aa964122(SQL.90).aspx
http://technet.microsoft.com/en-us/sqlserver/gg545008.aspx
Regards
IgorMi
May 8, 2013 at 3:12 pm
Hi
You can use these links to start:
http://msdn.microsoft.com/en-us/library/ms189852(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms187103(v=sql.105).aspx
May 3, 2013 at 10:51 am
IT researcher (5/3/2013)
Whether i can use selective xml index? Does it available in sql server 2008 r2 express?
It's available from sql server 2012.
May 3, 2013 at 6:43 am
ChrisM@Work (5/3/2013)
ChrisM@Work (5/3/2013)
IgorMi (5/3/2013)
<<snip>>Queries having WHERE clause connected by AND operators are evaluated from left to right in the order they are written.
What is the source for this statement? ...
May 3, 2013 at 4:34 am
ChrisM@Work (5/3/2013)
IgorMi (5/3/2013)
ChrisM@Work (5/3/2013)
IgorMi (5/3/2013)
ChrisM@Work (5/3/2013)
IgorMi (5/3/2013)
Hi
SELECT sum(CONVERT(float, ft.amount))
FROM filetransaction ft
WHERE ft.fileid <>332 and ISNUMERIC(ft.amount)=1
Check this also http://www.sqlservercentral.com/articles/IsNumeric/71512/
Regards
IgorMi
Which of those two filters will SQL Server apply first?
Queries having...
May 3, 2013 at 4:01 am
ChrisM@Work (5/3/2013)
IgorMi (5/3/2013)
ChrisM@Work (5/3/2013)
IgorMi (5/3/2013)
Hi
SELECT sum(CONVERT(float, ft.amount))
FROM filetransaction ft
WHERE ft.fileid <>332 and ISNUMERIC(ft.amount)=1
Check this also http://www.sqlservercentral.com/articles/IsNumeric/71512/
Regards
IgorMi
Which of those two filters will SQL Server apply first?
Queries having WHERE clause...
May 3, 2013 at 3:56 am
ChrisM@Work (5/3/2013)
IgorMi (5/3/2013)
Hi
SELECT sum(CONVERT(float, ft.amount))
FROM filetransaction ft
WHERE ft.fileid <>332 and ISNUMERIC(ft.amount)=1
Check this also http://www.sqlservercentral.com/articles/IsNumeric/71512/
Regards
IgorMi
Which of those two filters will SQL Server apply first?
Filters in queries having WHERE clause...
May 3, 2013 at 3:50 am
IT researcher (5/3/2013)
I don't know much about xml indexing. But for other...
May 3, 2013 at 3:36 am
Hi,
Why do you need two databases? What is the advantage of having two databases?
Having one database with a good backup strategy is enough. This is in use at quite big...
May 3, 2013 at 3:21 am
Hi
SELECT sum(CONVERT(float, ft.amount))
FROM filetransaction ft
WHERE ft.fileid <>332 and ISNUMERIC(ft.amount)=1
Check this also http://www.sqlservercentral.com/articles/IsNumeric/71512/
Regards
IgorMi
May 3, 2013 at 3:15 am
Hi,
Because you use exist() you should create FOR PATH type xml index.
Regards
IgorMi
May 3, 2013 at 2:58 am
gcresse (5/2/2013)
May 3, 2013 at 2:33 am
Hi,
I got interested in your question.
Did you check this http://cathydumas.com/2012/04/23/changing-an-analysis-services-instance-to-tabular-mode/
Please provide a feedback for this.
Regards,
IgorMi
May 2, 2013 at 9:59 am
Hi,
As you said you have big tables, then enabling trace flag 2371 can be of asset for your databases. See this
Regards,
IgorMi
May 2, 2013 at 9:17 am
Hi,
Do you have a snapshot created for that database? If yes, then you must drop it first.
You can also check if you have any opened sessions to the database you...
May 2, 2013 at 9:05 am
Viewing 15 posts - 916 through 930 (of 1,170 total)